<!DOCTYPE html>
<html lang="zh">
<head>
    <meta charset="UTF-8">
    <title>星际换电</title>
    <style>
    * {
        box-sizing: border-box;
    }
        html , body {
          width: 100%;
          height: 100%;
          margin: 0;
          padding: 0;
        }
        .left {
            display: inline-block;
            width: 25%;
            height: 100%;
            overflow: auto;
            border-right: 1px solid #DFE3EB;
            padding: 10px
        }
        .right {
            display: inline-block;
            width: 75%;
            height: 100%;
            padding: 10px;
            overflow: auto;
        }
        .index {
            font-weight: bold;
            font-size: 25px;
        }
        li {
            list-style: none;
            padding: 5px;
        }
        .first-li {
            font-weight: bold;
            font-size: 20px;
        }
        .second-li {
            font-weight: bold;
        }
        .third-li {
            font-weight: normal;
        }
        .block {
            display: block;
        }
        table {
            width: 100%;
            margin-top: 10px;
            border-color: #E8E8E8;
        }
        .first-tr {
            text-align: center;
        }
        tr:hover {
            background: #ECF9FF;
        }
        td {
            font-weight: normal;
            padding: 5px;
            white-space: nowrap;
        }
        a {
            color: #000000;
            background-color: transparent;
            text-decoration: none;
            outline: none;
            cursor: pointer;
        }
        .group {
            color: green;
        }
        .group-list {
            color: #1890ff;
        }
    </style>
</head>
<body><span class="left"><center class="index">目录</center>
<hr><ul>
<li class="first-li"><a class="group" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-from" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-to">1 用户服务</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-diagrams-from" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-from" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-column-from" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-views-from" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-views-column-from" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-dicts-from" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-dicts-column-from" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-from" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-to">2 电柜服务</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-diagrams-from" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-from" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-from" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-views-from" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-views-column-from" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-dicts-from" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-dicts-column-from" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-from" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-to">3 电池服务</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-diagrams-from" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-from" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-from" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-views-from" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-views-column-from" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-dicts-from" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-dicts-column-from" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-from" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-to">4 加盟商服务</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-diagrams-from" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-from" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-from" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-views-from" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-views-column-from" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-dicts-from" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-dicts-column-from" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-from" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-to">5 财务服务</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-diagrams-from" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-from" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-from" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-views-from" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-views-column-from" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-dicts-from" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-dicts-column-from" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-from" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-to">6 订单服务</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-diagrams-from" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-from" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-column-from" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-views-from" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-views-column-from" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-dicts-from" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-dicts-column-from" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-__defaultGroup-from" href="#group-__defaultGroup-to">7 默认分类</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-diagrams-from" href="#group-__defaultGroup-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-entities-from" href="#group-__defaultGroup-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-__defaultGroup-entities-column-from" href="#group-__defaultGroup-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-views-from" href="#group-__defaultGroup-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-__defaultGroup-views-column-from" href="#group-__defaultGroup-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-dicts-from" href="#group-__defaultGroup-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-__defaultGroup-dicts-column-from" href="#group-__defaultGroup-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul></ul>
</span><span  class="right"><ul>

<li class="first-li"><a class="group" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-from">1 用户服务</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-diagrams-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-diagrams-from">1.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-from">1.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>用户详情表</td><td>it_user</td><td></td></tr>
<tr><td>用户消费详情表</td><td>it_user_consumption</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-column-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-column-from">1.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-column-EC6E6717-B3B3-429A-A71C-5A2DDBB19EFB-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-column-EC6E6717-B3B3-429A-A71C-5A2DDBB19EFB-from">1.2.2.1 it_user[用户详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td>20</td><td>√</td><td></td></tr>
<tr><td>user_idcard</td><td>身份证</td><td>INT</td><td>18</td><td></td><td></td></tr>
<tr><td>user_name</td><td>真实姓名</td><td>VARCHAR</td><td>56</td><td></td><td></td></tr>
<tr><td>user_phone</td><td>手机号码</td><td>VARCHAR</td><td>11</td><td></td><td></td></tr>
<tr><td>user_password</td><td>密码</td><td>VARCHAR</td><td>20</td><td></td><td></td></tr>
<tr><td>user_state</td><td>用户账号状态</td><td>VARCHAR</td><td>11</td><td></td><td>用户状态 NORMAL 正常 | BAN 禁用 | CANCEL 注销</td></tr>
<tr><td>register_time</td><td>注册时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>overdue_times</td><td>逾期次数</td><td>INT</td><td>11</td><td></td><td>逾期次数>=3次,禁用账号</td></tr>
<tr><td>penal_sum</td><td>违约金</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>total_money</td><td>累计消费</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-column-6F595DF2-50F5-4D9F-A06E-65B6ACCA3752-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-entities-column-6F595DF2-50F5-4D9F-A06E-65B6ACCA3752-from">1.2.2.2 it_user_consumption[用户消费详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>cons_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>user_id</td><td>关联的用户id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>amount</td><td>总消费金额</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>type</td><td>类型</td><td>VARCHAR</td><td>32</td><td></td><td>月卡|押金</td></tr>
<tr><td>start_time</td><td>开始时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>end_time</td><td>结束时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-views-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-views-from">1.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-views-column-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-views-column-from">1.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-dicts-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-dicts-from">1.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-dicts-column-to" href="#group-2C6F8E41-6396-4389-AD76-0D5B656CFF08-dicts-column-from">1.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-from">2 电柜服务</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-diagrams-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-diagrams-from">2.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-from">2.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>电柜表</td><td>it_box</td><td></td></tr>
<tr><td>电柜电池中间表</td><td>it_box_battery</td><td></td></tr>
<tr><td>电柜申请表</td><td>it_box_apply</td><td></td></tr>
<tr><td>电柜发放记录表</td><td>it_box_allocation</td><td></td></tr>
<tr><td>电柜发放详情表</td><td>it_box_details</td><td></td></tr>
<tr><td>电柜维修记录表</td><td>it_box_maintenance</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-from">2.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-D7B9A3C3-BBB1-40B6-B011-9AAB469786BF-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-D7B9A3C3-BBB1-40B6-B011-9AAB469786BF-from">2.2.2.1 it_box[电柜表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>box_id</td><td>电柜id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>box_num</td><td>电柜编号</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>agent_id</td><td>加盟商id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>use_count</td><td>用户使用次数</td><td>VARCHAR</td><td>11</td><td></td><td></td></tr>
<tr><td>box_position</td><td>电柜位置</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>box_battery_quantity</td><td>电柜电池数量</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>install_time</td><td>安装时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>maintenance_time</td><td>维修时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-A8082456-526D-47F5-A4F2-56C1C878A2FE-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-A8082456-526D-47F5-A4F2-56C1C878A2FE-from">2.2.2.2 it_box_battery[电柜电池中间表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>box_battery_id</td><td>电柜电池id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>box_id</td><td>电柜id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>battery_id</td><td>电池id</td><td>INT</td><td>11</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-F77AC46B-5CED-4363-A2A4-3549DF4B6689-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-F77AC46B-5CED-4363-A2A4-3549DF4B6689-from">2.2.2.3 it_box_apply[电柜申请表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>apply_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>allocation_id</td><td>发放记录id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>income_id</td><td>申请方(低级代理 | 网点)</td><td>null</td><td>11</td><td></td><td></td></tr>
<tr><td>outform_id</td><td>发放方(高级代理 | admin)</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>apply_num</td><td>申请数量</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>apply_image</td><td>申请时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>apply_createtime</td><td>申请时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>allocation_time</td><td>发放时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>state</td><td>发放状态</td><td>INT</td><td>11</td><td></td><td>0申请中 1 已接收</td></tr>
</table>
</li>

 <li><a class="block" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-5482E362-F362-430F-BD20-3F1FA8823581-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-5482E362-F362-430F-BD20-3F1FA8823581-from">2.2.2.4 it_box_allocation[电柜发放记录表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>details_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>apply_id</td><td>申请表id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>income_id</td><td>申请方(低级代理 | 网点)</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>outform_id</td><td>发放方(高级代理 | admin)</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>allocation_num</td><td>发放数量</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>allocation_account</td><td>发放操作人</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>allocation_explain</td><td>发放操作说明</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
<tr><td>apply_createtime</td><td>申请时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>allocation_time</td><td>发放时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>state</td><td>发放状态</td><td>INT</td><td>11</td><td></td><td>0待发放 1 已发放</td></tr>
</table>
</li>

 <li><a class="block" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-FE158A7B-D031-44CF-9CCD-720654B4D3E0-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-FE158A7B-D031-44CF-9CCD-720654B4D3E0-from">2.2.2.5 it_box_details[电柜发放详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>details_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>allocation_id</td><td>关联电柜发放记录表 id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>box_id</td><td>关联电柜表  id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>box_image</td><td>电柜图片表</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-3FE7CA2D-BEF8-4CE8-847A-BE1FD3556B11-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-entities-column-3FE7CA2D-BEF8-4CE8-847A-BE1FD3556B11-from">2.2.2.6 it_box_maintenance[电柜维修记录表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>maintenance_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>location_id</td><td>申请维修站点</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>income_id</td><td>申请维修代理商</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>apply_time</td><td>申请维修时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>maintenance_reason</td><td>维修原因</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
<tr><td>box_id</td><td>关联电柜表  id</td><td>INT</td><td>11</td><td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-views-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-views-from">2.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-views-column-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-views-column-from">2.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-dicts-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-dicts-from">2.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-47C39B43-CF95-4004-9F19-02F4B864B5CC-dicts-column-to" href="#group-47C39B43-CF95-4004-9F19-02F4B864B5CC-dicts-column-from">2.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-from">3 电池服务</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-diagrams-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-diagrams-from">3.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-from">3.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>电池表</td><td>it_battery</td><td></td></tr>
<tr><td>电池申请记录表</td><td>it_battery_apply</td><td></td></tr>
<tr><td>电池发放记录表</td><td>it_battery_allocation</td><td></td></tr>
<tr><td>电池发放详情表</td><td>it_battery_details</td><td></td></tr>
<tr><td>电池维修记录表</td><td>it_battery_maintenance</td><td></td></tr>
<tr><td>电池使用记录表</td><td>it_battery_use</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-from">3.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-C864FB8A-4B52-4452-9E9D-C4095474BE71-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-C864FB8A-4B52-4452-9E9D-C4095474BE71-from">3.2.2.1 it_battery[电池表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>battery_id</td><td>主键Id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>battery_num</td><td>电池编号</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>battery_model</td><td>电池型号</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>battery_image</td><td>电池图片</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
<tr><td>agent_id</td><td>加盟商id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>use_count</td><td>累计使用次数</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>battery_state</td><td>状态</td><td>VARCHAR</td><td></td><td></td><td>0 未发放  1已发放  2使用中 3维修中 4充电中 5可使用</td></tr>
<tr><td>box_id</td><td>电柜Id</td><td>INT</td><td>11</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-BD72521C-4180-46AD-8552-43BE266FCCC8-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-BD72521C-4180-46AD-8552-43BE266FCCC8-from">3.2.2.2 it_battery_apply[电池申请记录表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>apply_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>allocation_id</td><td>发放记录id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>income_id</td><td>申请方(低级代理 | 网点)</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>outform_id</td><td>发放方(高级代理 | admin)</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>apply_num</td><td>申请数量</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>apply_image</td><td>申请附件</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
<tr><td>apply_createtime</td><td>申请时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>allocation_time</td><td>发放时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>state</td><td>发放状态</td><td>INT</td><td>11</td><td></td><td>0申请中 1 已接收</td></tr>
</table>
</li>

 <li><a class="block" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-6116B6BC-D3D4-4D7E-B54B-7F11E97753CA-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-6116B6BC-D3D4-4D7E-B54B-7F11E97753CA-from">3.2.2.3 it_battery_allocation[电池发放记录表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>allocation_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>apply_id</td><td>申请表id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>income_id</td><td>申请方(低级代理 | 网点)</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>outform_id</td><td>发放方(高级代理 | admin)</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>allocation_num</td><td>发放数量</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>allocation_account</td><td>发放操作人</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>allocation_explain</td><td>发放操作说明</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
<tr><td>apply_createtime</td><td>申请时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>allocation_time</td><td>发放时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>state</td><td>发放状态</td><td>INT</td><td>11</td><td></td><td>0待发放 1 已发放</td></tr>
</table>
</li>

 <li><a class="block" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-079933CA-9E3A-4876-B168-E054E8067BA0-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-079933CA-9E3A-4876-B168-E054E8067BA0-from">3.2.2.4 it_battery_details[电池发放详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>details_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>allocation_id</td><td>关联电池发放记录表 id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>battery_id</td><td>关联电池表  id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>battery_image</td><td>电池图片表</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-5C000F90-DBCB-40B1-8ED5-12B9C31C03E9-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-5C000F90-DBCB-40B1-8ED5-12B9C31C03E9-from">3.2.2.5 it_battery_maintenance[电池维修记录表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>maintenance_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>location_id</td><td>申请维修站点</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>income_id</td><td>申请维修代理商</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>apply_time</td><td>申请维修时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>maintenance_reason</td><td>维修原因</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
<tr><td>battery_id</td><td>关联电池表  id</td><td>INT</td><td>11</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-89E0E639-E600-4192-A318-5E904D9F0E05-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-entities-column-89E0E639-E600-4192-A318-5E904D9F0E05-from">3.2.2.6 it_battery_use[电池使用记录表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>use_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>final_agent_id</td><td>最后一次使用电池所属代理商</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>final_site_id</td><td>最后一次使用站点</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>user_id</td><td>关联用户Id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>use_start_time</td><td>开始使用时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>use_end_time</td><td>使用结束时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>return_agent_id</td><td>电池归还地所属代理商</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>return_site_id</td><td>电池归还的站点</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>battery_id</td><td>关联电池表 id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>status</td><td>状态</td><td>INT</td><td>11</td><td></td><td>0已结束  1正在使用</td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-views-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-views-from">3.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-views-column-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-views-column-from">3.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-dicts-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-dicts-from">3.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-dicts-column-to" href="#group-5B2D6A09-BC53-4C90-A3A6-4D01CA6C2F7D-dicts-column-from">3.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-from">4 加盟商服务</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-diagrams-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-diagrams-from">4.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-from">4.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>加盟商表</td><td>it_agent</td><td></td></tr>
<tr><td>合同表</td><td>it_contract</td><td></td></tr>
<tr><td>仓库表</td><td>it_storage</td><td></td></tr>
<tr><td>加盟关系表</td><td>it_agent_relation</td><td></td></tr>
<tr><td>维修表</td><td>it_maintenance</td><td></td></tr>
<tr><td>加盟商申请加盟表</td><td>it_agent_apply</td><td></td></tr>
<tr><td>加盟商账号</td><td>it_agent_account</td><td></td></tr>
<tr><td>加盟商设备订单</td><td>it_agent_order</td><td></td></tr>
<tr><td>加盟商续期表</td><td>it_agent_renewal</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-from">4.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-90783FE2-2172-415E-B1C7-903722BE5EDF-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-90783FE2-2172-415E-B1C7-903722BE5EDF-from">4.2.2.1 it_agent[加盟商表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>agent_id</td><td>加盟商Id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>agent_name</td><td>加盟商姓名</td><td>VARCHAR</td><td>50</td><td></td><td></td></tr>
<tr><td>agent_company</td><td>加盟商公司名（工商名字）</td><td>VARCHAR</td><td>120</td><td></td><td></td></tr>
<tr><td>agent_level</td><td>加盟商等级</td><td>INT</td><td>11</td><td></td><td>1 | 2 | 3</td></tr>
<tr><td>agent_state</td><td>状态</td><td>VARCHAR</td><td>32</td><td></td><td>正常|到期</td></tr>
<tr><td>province</td><td>省份</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>district</td><td>区</td><td>VARCHAR</td><td>64</td><td></td><td></td></tr>
<tr><td>agent_address</td><td>加盟商地址</td><td>VARCHAR</td><td>120</td><td></td><td></td></tr>
<tr><td>agent_tel</td><td>加盟商座机</td><td>VARCHAR</td><td>12</td><td></td><td></td></tr>
<tr><td>agent_phone</td><td>加盟商手机</td><td>VARCHAR</td><td>11</td><td></td><td></td></tr>
<tr><td>contract_id</td><td>签订的合同id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>join_time</td><td>加盟时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>out_time</td><td>加盟到期时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>storage_id</td><td>加盟仓库id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>storage_address</td><td>仓库地址</td><td>VARCHAR</td><td>120</td><td></td><td></td></tr>
<tr><td>total_money</td><td>加盟总费用</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-E115298E-BFB3-4575-B9DF-78A783CF1569-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-E115298E-BFB3-4575-B9DF-78A783CF1569-from">4.2.2.2 it_contract[合同表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>contract_id</td><td>合同id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>contract_type</td><td>合同类型</td><td>VARCHAR</td><td>32</td><td></td><td>加盟费 | 设备费 | 场地费</td></tr>
<tr><td>contract_state</td><td>合同状态</td><td>VARCHAR</td><td>32</td><td></td><td>正常|过期</td></tr>
<tr><td>contract_image</td><td>合同照片</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
<tr><td>contract_money</td><td>合同金额</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>contract_limit</td><td>合同年限</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>start_time</td><td>签订时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>end_time</td><td>到期时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>first_party</td><td>甲方id</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>second_party</td><td>乙方id</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-61DDF678-E928-4657-8E4F-B25D6455CE38-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-61DDF678-E928-4657-8E4F-B25D6455CE38-from">4.2.2.3 it_storage[仓库表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>storage_id</td><td>仓库Id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>agent_id</td><td>加盟商Id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>agent_address</td><td>仓库地址</td><td>VARCHAR</td><td>120</td><td></td><td></td></tr>
<tr><td>agent_size</td><td>仓库面积</td><td>DECIMAL</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-3A9C4234-0F4D-43C9-B42D-ADA5AA24A74B-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-3A9C4234-0F4D-43C9-B42D-ADA5AA24A74B-from">4.2.2.4 it_agent_relation[加盟关系表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>relation_id</td><td>关系ID</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>first_partyId</td><td>甲方</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>second_partyId</td><td>乙方</td><td>INT</td><td>11</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-57A69C3D-E9AE-49A0-8FBD-6226C5679EB4-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-57A69C3D-E9AE-49A0-8FBD-6226C5679EB4-from">4.2.2.5 it_maintenance[维修表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>maintenance_id</td><td>ID</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>type</td><td>类型</td><td>VARCHAR</td><td>32</td><td></td><td>box:电柜 | battery:电池</td></tr>
<tr><td>commodity_id</td><td>产品Id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>money</td><td>维修费用</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>start_time</td><td>开始时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>end_time</td><td>结束时间</td><td>DECIMAL</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-1079E32C-289D-48F3-B250-46F94371D57F-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-1079E32C-289D-48F3-B250-46F94371D57F-from">4.2.2.6 it_agent_apply[加盟商申请加盟表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>apply_id</td><td>申请表id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>apply_name</td><td>申请人</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>apply_superior_id</td><td>申请的上级id</td><td>INT</td><td>11</td><td></td><td>0一级  *代表上级Id(具体的上级Id)</td></tr>
<tr><td>apply_type</td><td>申请的类别</td><td>VARCHAR</td><td>32</td><td></td><td>申请的代理级别 一级 | 二级 | 网点</td></tr>
<tr><td>apply_company</td><td>申请公司</td><td>null</td><td>32</td><td></td><td></td></tr>
<tr><td>apply_time</td><td>申请时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>apply_data</td><td>申请资料</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
<tr><td>apply_state</td><td>申请状态</td><td>INT</td><td>11</td><td></td><td>0待审批1成功2驳回</td></tr>
<tr><td>apply_remarks</td><td>备注</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-FFC71372-FBE6-4E86-B704-D673262CC110-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-FFC71372-FBE6-4E86-B704-D673262CC110-from">4.2.2.7 it_agent_account[加盟商账号]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>account_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>account_name</td><td>账号名</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>account_password</td><td>密码</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>agent_level</td><td>加盟商等级</td><td>INT</td><td>11</td><td></td><td>1 | 2 | 3</td></tr>
<tr><td>status</td><td>状态</td><td>INT</td><td>32</td><td></td><td>1启用|2禁用</td></tr>
</table>
</li>

 <li><a class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-41B534D9-0817-4FAC-A088-454A605FEAF3-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-41B534D9-0817-4FAC-A088-454A605FEAF3-from">4.2.2.8 it_agent_order[加盟商设备订单]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>order_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>agent_id</td><td>加盟商id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>device_type</td><td>设备类型</td><td>INT</td><td>11</td><td></td><td>1电池2电柜</td></tr>
<tr><td>device_num</td><td>设备数量</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>total</td><td>设备总金额</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>create_time</td><td>订单创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-11FF9EB5-CC71-447A-B2F2-B5C2CD2A5837-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-entities-column-11FF9EB5-CC71-447A-B2F2-B5C2CD2A5837-from">4.2.2.9 it_agent_renewal[加盟商续期表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>renewal_id</td><td>主键id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>agent_id</td><td>加盟商id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>contract_id</td><td>合同id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>renewal_time</td><td>续期时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>renewal_mone</td><td>续期金额</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>renewal_limit</td><td>续期年限</td><td>VARCHAR</td><td>32</td><td></td><td></td></tr>
<tr><td>remarks</td><td>备注</td><td>VARCHAR</td><td>2048</td><td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-views-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-views-from">4.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-views-column-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-views-column-from">4.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-dicts-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-dicts-from">4.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-dicts-column-to" href="#group-FF1BE6FB-6183-4624-9A34-5DE7248373AD-dicts-column-from">4.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-from">5 财务服务</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-diagrams-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-diagrams-from">5.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-from">5.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>财务总表</td><td>it_financial</td><td></td></tr>
<tr><td>区县财务详情表（二级代理商）</td><td>it_financial_county</td><td></td></tr>
<tr><td>省级财务详情表（一级代理商）</td><td>it_financial_economize</td><td></td></tr>
<tr><td>加盟详情表</td><td>it_agent_info</td><td></td></tr>
<tr><td>设备详情表</td><td>it_equipment_info</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-from">5.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-4FDA0F72-4C51-4690-ACDF-6C07E237C381-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-4FDA0F72-4C51-4690-ACDF-6C07E237C381-from">5.2.2.1 it_financial[财务总表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>financial_id</td><td>主键ID</td><td>INT</td><td>20</td><td>√</td><td></td></tr>
<tr><td>transaction_date</td><td>交易日期</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>franchise_fee</td><td>加盟费</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>equipment_cost</td><td>材料费（电池和电柜）</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>user_revenue</td><td>用户收入</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>deposit</td><td>押金</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>ground</td><td>场地费（一个服务网点200快）</td><td>DECIMAL</td><td>7</td><td></td><td></td></tr>
<tr><td>maintain</td><td>运维支出</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>commission</td><td>返佣</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>amount</td><td>总金额</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>description</td><td>交易描述</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
<tr><td>status</td><td>交易状态</td><td>VARCHAR</td><td>20</td><td></td><td>入账、退款</td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>updated_at</td><td>更新时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-72CB526A-0F6C-4683-B3CA-1CBF01521205-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-72CB526A-0F6C-4683-B3CA-1CBF01521205-from">5.2.2.2 it_financial_county[区县财务详情表（二级代理商）]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>fc_id</td><td>详细ID</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>fc_amount</td><td>总金额</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>box_id</td><td>电柜ID</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户ID</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>user_name</td><td>用户名字</td><td>VARCHAR</td><td>56</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-14656A0D-8FE4-49B7-A782-AF66765A595F-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-14656A0D-8FE4-49B7-A782-AF66765A595F-from">5.2.2.3 it_financial_economize[省级财务详情表（一级代理商）]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>fe_id</td><td>主键</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>fe_amount</td><td>总金额</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>created_at</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>county_id</td><td>区县ID</td><td>INT</td><td>11</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-44FC4549-DC30-4CBC-86FF-87E97D399173-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-44FC4549-DC30-4CBC-86FF-87E97D399173-from">5.2.2.4 it_agent_info[加盟详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>agent_info_id</td><td>主键</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>agent_id</td><td>商盟商Id</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>agent_time</td><td>加盟时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>money</td><td>加盟金额</td><td>DECIMAL</td><td>7</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-CDA27F80-8771-437A-9B53-ED9644DB184A-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-entities-column-CDA27F80-8771-437A-9B53-ED9644DB184A-from">5.2.2.5 it_equipment_info[设备详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>equipment_id</td><td>id</td><td>INT</td><td>11</td><td>√</td><td></td></tr>
<tr><td>battery_ids</td><td>电池数组（用，分割）</td><td>VARCHAR</td><td>50</td><td></td><td></td></tr>
<tr><td>battery_num</td><td>数量</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>battery_money</td><td>电池总价</td><td>DECIMAL</td><td>7</td><td></td><td></td></tr>
<tr><td>box_ids</td><td>电柜数组（用，分割）</td><td>VARCHAR</td><td>50</td><td></td><td></td></tr>
<tr><td>box_num</td><td>数量</td><td>INT</td><td>11</td><td></td><td></td></tr>
<tr><td>box_money</td><td>电柜总价</td><td>DATETIME</td><td>7</td><td></td><td></td></tr>
<tr><td>equipment_money</td><td>总价</td><td>DECIMAL</td><td>7</td><td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-views-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-views-from">5.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-views-column-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-views-column-from">5.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-dicts-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-dicts-from">5.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-dicts-column-to" href="#group-DD6CFF71-824B-4363-AB0A-1B81564FCCCE-dicts-column-from">5.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-from">6 订单服务</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-diagrams-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-diagrams-from">6.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-from">6.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>订单表详情表</td><td>it_order_info</td><td></td></tr>
<tr><td>押金详情表</td><td>it_deposit</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-column-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-column-from">6.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-column-4C00C0C7-965C-4D1B-BF8C-81B4FB8B820E-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-column-4C00C0C7-965C-4D1B-BF8C-81B4FB8B820E-from">6.2.2.1 it_order_info[订单表详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>order_id</td><td>主键id</td><td>VARCHAR</td><td>32</td><td>√</td><td></td></tr>
<tr><td>order_uuid</td><td>订单号</td><td>VARCHAR</td><td>32</td><td></td><td>雪花ID</td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td>20</td><td></td><td></td></tr>
<tr><td>user_name</td><td>用户名字</td><td>VARCHAR</td><td>56</td><td></td><td></td></tr>
<tr><td>agent_id</td><td>加盟商id</td><td>INT</td><td>20</td><td></td><td></td></tr>
<tr><td>box_id</td><td>电柜id</td><td>INT</td><td>20</td><td></td><td></td></tr>
<tr><td>battery_id</td><td>电池id</td><td>INT</td><td>20</td><td></td><td></td></tr>
<tr><td>order_status</td><td>订单状态</td><td>VARCHAR</td><td>20</td><td></td><td>成功 | 退款</td></tr>
<tr><td>amount</td><td>订单金额</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>order_type</td><td>套餐类型</td><td>VARCHAR</td><td>20</td><td></td><td>周卡 100元 | 月卡 300元 | 季卡 800元 | 年卡 3000元</td></tr>
<tr><td>start_time</td><td>订单创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>end_time</td><td>订单结束时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>superior</td><td>上级编号数组</td><td>VARCHAR</td><td>32</td><td></td><td>【1，6】 1表示一级代理ID 6代表二级代理ID</td></tr>
</table>
</li>

 <li><a class="block" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-column-E41EE827-5BDA-45A3-87EC-CE3D5F77B0F3-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-entities-column-E41EE827-5BDA-45A3-87EC-CE3D5F77B0F3-from">6.2.2.2 it_deposit[押金详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>deposit_id</td><td>主键id</td><td>INT</td><td>32</td><td>√</td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>money</td><td>押金金额</td><td>DECIMAL</td><td>17</td><td></td><td></td></tr>
<tr><td>start_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>end_time</td><td>结束时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>state</td><td>押金状态</td><td>VARCHAR</td><td>20</td><td></td><td>正常 | 退款</td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-views-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-views-from">6.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-views-column-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-views-column-from">6.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-dicts-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-dicts-from">6.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-dicts-column-to" href="#group-AA9B4DF8-332F-42ED-AFCC-9B477A7B0D48-dicts-column-from">6.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-__defaultGroup-to" href="#group-__defaultGroup-from">7 默认分类</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-__defaultGroup-diagrams-to" href="#group-__defaultGroup-diagrams-from">7.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-__defaultGroup-entities-to" href="#group-__defaultGroup-entities-from">7.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-__defaultGroup-entities-column-to" href="#group-__defaultGroup-entities-column-from">7.2.2 表列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-__defaultGroup-views-to" href="#group-__defaultGroup-views-from">7.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-__defaultGroup-views-column-to" href="#group-__defaultGroup-views-column-from">7.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-__defaultGroup-dicts-to" href="#group-__defaultGroup-dicts-from">7.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-__defaultGroup-dicts-column-to" href="#group-__defaultGroup-dicts-column-from">7.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li></ul></span></body>
</html>